arachnode.net

arachnode.zip (77,6 MB)
http://arachnode.net 2.6 release +lucene.net

Silmaril's Code Generation Tool - MS SQL

Generates c# classes from MS-SQL database.Each class has it's Constructors,CRUD Methods and methods fetches data according foreign keys.

ASP.NET 2.0 VS Custom Renderer - Data Bindable Image Control

DBIC.zip (320 kB)
This project contains a Web Custom Control for rendering images directly from the database. Can be used with image fields, with text, date or number fields (it generates an image containing the text) and also with URL fields (like a usual image control).

ExpressMaint

FileSystemHelper SQL Server CLR

FileSystemHelper SQL Server CLR provides a collection of CLR stored procedures and functions for interacting with the file system. Using these stored procedures and functions will allow you to avoid enabling xp_cmdshell on your SQL Server instances.

Index Analysis

Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.

LittleUmph

littleumph.zip (417 kB)
It's a little library to help you to alleviate some of the mundane stuff during your development. It has some nifty stuff like a neat database wrapper, conversion utilities, string functions and vast of other mini helpers to improve the efficiency and consistency of your code.

Mini SQL Query - Moved to GitHub

Mini SQL Query is a minimalist SQL query tool for multiple databases is now on GitHub: https://github.com/paulkohler/minisqlquery

DTS Deployment and Packaging Tools

ncldts.zip (14,7 MB)
This project includes tools for extracting and deploying DTS (Not SSIS) packages to a SQL 2000/2005/2008 server. This is especially useful when deploying more than a couple of packages, or a SQL upgrade where DTS will still be used.

SQLCLR Cmd Exec Framework Example

For users of MS SQL Server, xp_cmdshell is a utility that we usually want to have disabled. However there are still cases where calling a command line is needed. This project provides an framework/example to make command line calls. It is not meant as an xp_cmdshell replacement but as a workaround.

SQLCLR File Functions

File Functions for SQL. Implemented as a SQLCLR assembly. Compatible with SQL 2008, 2008R2, and 2012. May be compatible with SQL 2005 & 2014 (untested).

SQL Server Inventory, Configuration Monitoring, and Logging Infrastructure

nclsqlinv.zip (8,3 MB)
This project is designed to allow inventorying and configuration management of SQL Servers in your environment. Including SQL Server configurations, databases, database configurations, database file configurations. And more.

SQL Bandwidth Meter Log Parser

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

SQL 2005 Service Manager

Welcome to the SQL 2005 Service Manager project. SQL 2005 Service Manager is a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server. It allows the management and monitoring of all local SQL Server related services from a convenient system tray application. Please note that there is a Vista specific release as well as the standard XP/Win2003 release. There are no differences in functionality, the Vista release has just been modified to accomodate the UAC (User Account Control) feature.

SQL DMVStats

A SQL Server 2005 Dynamic Management View Performance Data Warehouse

SQL Installer.NET

SQL Installer.NET

SQL Live Monitor

sqlmonitor.zip (7,5 MB)
a .NET application that provides realtime performance data on the target SQL Server instance. No installation required, data displayed in realtime, and can also be logged to CSV for offline analysis. Will also capture SQL data for processing uing PAL.

SQLS

sqls.zip (921 kB)
SQLS is a simple SQL Server batch file generator. Designed to be used as part of implementations or patches to apply TSQL scripts to a SQL Server. SQL 2000 'osql' and SQL 2005/8 'sqlcmd' are supported.

StringHelper SQL Server CLR

StringHelper SQL Server CLR provides a collection of CLR stored procedures and functions useful for manipulating and interacting with string data. Using these stored procedures and functions will allow you to bring the flexibility of .NET into the database.

WebTools - XML XQuery class, ASP.NET Server Controls

WebTools.zip (329 kB)
A solution for storing serialized objects in an XML data type column and using XQuery to query into the serialized XML and retrieve records. Also includes the WebTools.UI library which is a collection of ASP.NET server controls for rollover images and other controls.